Overview

Dataset statistics

Number of variables32
Number of observations85116
Missing cells0
Missing cells (%)0.0%
Duplicate rows5147
Duplicate rows (%)6.0%
Total size in memory20.8 MiB
Average record size in memory256.0 B

Variable types

NUM27
CAT4
DATE1

Warnings

Dataset has 5147 (6.0%) duplicate rows Duplicates
PUNTO_MUESTREO has a high cardinality: 100 distinct values High cardinality
H02 is highly correlated with H01 and 14 other fieldsHigh correlation
H01 is highly correlated with H02 and 14 other fieldsHigh correlation
H03 is highly correlated with H01 and 14 other fieldsHigh correlation
H04 is highly correlated with H01 and 14 other fieldsHigh correlation
H05 is highly correlated with H01 and 14 other fieldsHigh correlation
H06 is highly correlated with H01 and 14 other fieldsHigh correlation
H07 is highly correlated with H01 and 14 other fieldsHigh correlation
H08 is highly correlated with H01 and 14 other fieldsHigh correlation
H09 is highly correlated with H01 and 16 other fieldsHigh correlation
H10 is highly correlated with H01 and 22 other fieldsHigh correlation
H11 is highly correlated with H09 and 10 other fieldsHigh correlation
H12 is highly correlated with H10 and 8 other fieldsHigh correlation
H13 is highly correlated with H10 and 7 other fieldsHigh correlation
H14 is highly correlated with H10 and 7 other fieldsHigh correlation
H15 is highly correlated with H10 and 7 other fieldsHigh correlation
H16 is highly correlated with H10 and 8 other fieldsHigh correlation
H17 is highly correlated with H10 and 9 other fieldsHigh correlation
H18 is highly correlated with H09 and 11 other fieldsHigh correlation
H19 is highly correlated with H01 and 19 other fieldsHigh correlation
H20 is highly correlated with H01 and 17 other fieldsHigh correlation
H21 is highly correlated with H01 and 15 other fieldsHigh correlation
H22 is highly correlated with H01 and 14 other fieldsHigh correlation
H23 is highly correlated with H01 and 14 other fieldsHigh correlation
H24 is highly correlated with H01 and 14 other fieldsHigh correlation
PUNTO_MUESTREO is highly correlated with MAGNITUD and 1 other fieldsHigh correlation
MAGNITUD is highly correlated with PUNTO_MUESTREOHigh correlation
CALLE is highly correlated with PUNTO_MUESTREOHigh correlation
H01 has 13537 (15.9%) zeros Zeros
H02 has 13547 (15.9%) zeros Zeros
H03 has 13586 (16.0%) zeros Zeros
H04 has 13593 (16.0%) zeros Zeros
H05 has 13636 (16.0%) zeros Zeros
H06 has 13622 (16.0%) zeros Zeros
H07 has 12823 (15.1%) zeros Zeros
H08 has 10868 (12.8%) zeros Zeros
H09 has 9345 (11.0%) zeros Zeros
H10 has 9106 (10.7%) zeros Zeros
H11 has 9067 (10.7%) zeros Zeros
H12 has 9056 (10.6%) zeros Zeros
H13 has 9043 (10.6%) zeros Zeros
H14 has 9036 (10.6%) zeros Zeros
H15 has 9019 (10.6%) zeros Zeros
H16 has 8958 (10.5%) zeros Zeros
H17 has 8944 (10.5%) zeros Zeros
H18 has 8971 (10.5%) zeros Zeros
H19 has 9638 (11.3%) zeros Zeros
H20 has 10515 (12.4%) zeros Zeros
H21 has 11299 (13.3%) zeros Zeros
H22 has 12549 (14.7%) zeros Zeros
H23 has 13518 (15.9%) zeros Zeros
H24 has 13509 (15.9%) zeros Zeros

Reproduction

Analysis started2021-11-23 18:58:20.543428
Analysis finished2021-11-23 19:01:29.657460
Duration3 minutes and 9.11 seconds
Software versionpandas-profiling v2.9.0
Download configurationconfig.yaml

Variables

ESTACION
Real number (ℝ≥0)

Distinct26
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean77.25984539
Minimum4
Maximum115
Zeros0
Zeros (%)0.0%
Memory size665.0 KiB

Quantile statistics

Minimum4
5-th percentile18
Q154
median102
Q3107
95-th percentile113
Maximum115
Range111
Interquartile range (IQR)53

Descriptive statistics

Standard deviation34.29314932
Coefficient of variation (CV)0.4438676929
Kurtosis-1.275209989
Mean77.25984539
Median Absolute Deviation (MAD)11
Skewness-0.4993198558
Sum6576049
Variance1176.02009
MonotocityNot monotonic
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%) 
10269668.2%
 
5968548.1%
 
10367948.0%
 
10664917.6%
 
2464817.6%
 
10761167.2%
 
5460987.2%
 
10853736.3%
 
5653116.2%
 
10423432.8%
 
Other values (16)2628930.9%
 
ValueCountFrequency (%) 
48501.0%
 
816541.9%
 
169941.2%
 
188781.0%
 
2464817.6%
 
ValueCountFrequency (%) 
11518722.2%
 
11415961.9%
 
11319182.3%
 
11219502.3%
 
11113441.6%
 

MAGNITUD
Categorical

HIGH CORRELATION

Distinct8
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size665.0 KiB
Relative Humidity(%)
21174 
Temperature(ºC)
20919 
Precipitation(l/m^2)
9313 
Wind Velocity(m/s)
9301 
Wind Direction
9269 
Other values (3)
15140 
ValueCountFrequency (%) 
Relative Humidity(%)2117424.9%
 
Temperature(ºC)2091924.6%
 
Precipitation(l/m^2)931310.9%
 
Wind Velocity(m/s)930110.9%
 
Wind Direction926910.9%
 
Solar Radiation(W/m^2)74888.8%
 
Barometric Pressure(mb)72518.5%
 
UV Radiation(mW/m^2)4010.5%
 
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%
Histogram of lengths of the category

Length

Max length23
Median length20
Mean length18.33072513
Min length14

PUNTO_MUESTREO
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct100
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size665.0 KiB
28079102_86_98
 
997
28079102_88_98
 
997
28079102_83_98
 
997
28079102_81_98
 
997
28079102_82_98
 
997
Other values (95)
80131 
ValueCountFrequency (%) 
28079102_86_989971.2%
 
28079102_88_989971.2%
 
28079102_83_989971.2%
 
28079102_81_989971.2%
 
28079102_82_989971.2%
 
28079054_82_989951.2%
 
28079102_89_989951.2%
 
28079054_81_989951.2%
 
28079016_86_989941.2%
 
28079054_83_989941.2%
 
Other values (90)7515888.3%
 
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%
Histogram of lengths of the category

Length

Max length14
Median length14
Mean length14
Min length14

ANO
Categorical

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size665.0 KiB
2019
32612 
2020
30943 
2021
21561 
ValueCountFrequency (%) 
20193261238.3%
 
20203094336.4%
 
20212156125.3%
 
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%
Histogram of lengths of the category

Length

Max length4
Median length4
Mean length4
Min length4

MES
Real number (ℝ≥0)

Distinct11
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.93646318
Minimum1
Maximum12
Zeros0
Zeros (%)0.0%
Memory size665.0 KiB

Quantile statistics

Minimum1
5-th percentile1
Q13
median6
Q39
95-th percentile12
Maximum12
Range11
Interquartile range (IQR)6

Descriptive statistics

Standard deviation3.197584695
Coefficient of variation (CV)0.5386346378
Kurtosis-1.035185623
Mean5.93646318
Median Absolute Deviation (MAD)3
Skewness0.09862280425
Sum505288
Variance10.22454788
MonotocityNot monotonic
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%) 
91244714.6%
 
183019.8%
 
580819.5%
 
379209.3%
 
477819.1%
 
876539.0%
 
276108.9%
 
772738.5%
 
672478.5%
 
1254046.3%
 
ValueCountFrequency (%) 
183019.8%
 
276108.9%
 
379209.3%
 
477819.1%
 
580819.5%
 
ValueCountFrequency (%) 
1254046.3%
 
1053996.3%
 
91244714.6%
 
876539.0%
 
772738.5%
 

DIA
Real number (ℝ≥0)

Distinct31
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15.67207106
Minimum1
Maximum31
Zeros0
Zeros (%)0.0%
Memory size665.0 KiB

Quantile statistics

Minimum1
5-th percentile2
Q18
median16
Q323
95-th percentile29
Maximum31
Range30
Interquartile range (IQR)15

Descriptive statistics

Standard deviation8.74661546
Coefficient of variation (CV)0.5581020803
Kurtosis-1.180626213
Mean15.67207106
Median Absolute Deviation (MAD)8
Skewness0.009673413372
Sum1333944
Variance76.503282
MonotocityNot monotonic
Histogram with fixed size bins (bins=31)
ValueCountFrequency (%) 
1528603.4%
 
1728593.4%
 
1928513.3%
 
2028493.3%
 
1628463.3%
 
928443.3%
 
2328373.3%
 
1428343.3%
 
1128323.3%
 
1028243.3%
 
Other values (21)5668066.6%
 
ValueCountFrequency (%) 
127993.3%
 
227843.3%
 
327943.3%
 
427643.2%
 
527803.3%
 
ValueCountFrequency (%) 
3115261.8%
 
3025533.0%
 
2924622.9%
 
2826883.2%
 
2727513.2%
 

H01
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1214
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean113.9855343
Minimum-12.2
Maximum964
Zeros13537
Zeros (%)15.9%
Memory size665.0 KiB

Quantile statistics

Minimum-12.2
5-th percentile0
Q11
median19.6
Q364
95-th percentile943
Maximum964
Range976.2
Interquartile range (IQR)63

Descriptive statistics

Standard deviation259.8324512
Coefficient of variation (CV)2.279521281
Kurtosis5.931314054
Mean113.9855343
Median Absolute Deviation (MAD)19.6
Skewness2.749579535
Sum9701992.74
Variance67512.90269
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
01353715.9%
 
125933.0%
 
311611.4%
 
364600.5%
 
9414440.5%
 
9424420.5%
 
9404400.5%
 
314310.5%
 
434290.5%
 
9474280.5%
 
Other values (1204)6475176.1%
 
ValueCountFrequency (%) 
-12.21< 0.1%
 
-12.11< 0.1%
 
-9.81< 0.1%
 
-9.61< 0.1%
 
-9.51< 0.1%
 
ValueCountFrequency (%) 
9641< 0.1%
 
9632< 0.1%
 
9625< 0.1%
 
96111< 0.1%
 
960440.1%
 

H02
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1212
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean113.785015
Minimum-13.1
Maximum964
Zeros13547
Zeros (%)15.9%
Memory size665.0 KiB

Quantile statistics

Minimum-13.1
5-th percentile0
Q11
median19
Q366
95-th percentile943
Maximum964
Range977.1
Interquartile range (IQR)65

Descriptive statistics

Standard deviation259.711522
Coefficient of variation (CV)2.282475613
Kurtosis5.957161453
Mean113.785015
Median Absolute Deviation (MAD)19
Skewness2.755593622
Sum9684925.34
Variance67450.07464
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
01354715.9%
 
125923.0%
 
311571.4%
 
9424390.5%
 
9404370.5%
 
9474360.5%
 
9414320.5%
 
434250.5%
 
594240.5%
 
9484200.5%
 
Other values (1202)6480776.1%
 
ValueCountFrequency (%) 
-13.11< 0.1%
 
-12.91< 0.1%
 
-10.51< 0.1%
 
-10.32< 0.1%
 
-10.22< 0.1%
 
ValueCountFrequency (%) 
9641< 0.1%
 
9632< 0.1%
 
9625< 0.1%
 
96111< 0.1%
 
96040< 0.1%
 

H03
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1193
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean113.6675266
Minimum-14.2
Maximum963
Zeros13586
Zeros (%)16.0%
Memory size665.0 KiB

Quantile statistics

Minimum-14.2
5-th percentile0
Q11
median18.3
Q367
95-th percentile943
Maximum963
Range977.2
Interquartile range (IQR)66

Descriptive statistics

Standard deviation259.5492299
Coefficient of variation (CV)2.283407036
Kurtosis5.981133997
Mean113.6675266
Median Absolute Deviation (MAD)18.3
Skewness2.760881496
Sum9674925.19
Variance67365.80273
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
01358616.0%
 
126013.1%
 
311901.4%
 
9424500.5%
 
9404380.5%
 
624330.5%
 
9484230.5%
 
9414210.5%
 
9474180.5%
 
434110.5%
 
Other values (1183)6474576.1%
 
ValueCountFrequency (%) 
-14.21< 0.1%
 
-13.91< 0.1%
 
-11.21< 0.1%
 
-11.11< 0.1%
 
-10.81< 0.1%
 
ValueCountFrequency (%) 
9632< 0.1%
 
9625< 0.1%
 
9618< 0.1%
 
96040< 0.1%
 
959580.1%
 

H04
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1180
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean113.7946767
Minimum-15.2
Maximum963
Zeros13593
Zeros (%)16.0%
Memory size665.0 KiB

Quantile statistics

Minimum-15.2
5-th percentile0
Q11
median17.8
Q368
95-th percentile943
Maximum963
Range978.2
Interquartile range (IQR)67

Descriptive statistics

Standard deviation259.4560609
Coefficient of variation (CV)2.280036892
Kurtosis5.984348155
Mean113.7946767
Median Absolute Deviation (MAD)17.8
Skewness2.761279366
Sum9685747.7
Variance67317.44753
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
01359316.0%
 
126533.1%
 
311711.4%
 
9424420.5%
 
9404360.5%
 
9484330.5%
 
9414290.5%
 
9464210.5%
 
474190.5%
 
564180.5%
 
Other values (1170)6470176.0%
 
ValueCountFrequency (%) 
-15.21< 0.1%
 
-14.71< 0.1%
 
-121< 0.1%
 
-11.81< 0.1%
 
-11.31< 0.1%
 
ValueCountFrequency (%) 
9631< 0.1%
 
9625< 0.1%
 
96113< 0.1%
 
96038< 0.1%
 
959530.1%
 

H05
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1178
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean113.7600246
Minimum-16
Maximum962
Zeros13636
Zeros (%)16.0%
Memory size665.0 KiB

Quantile statistics

Minimum-16
5-th percentile0
Q11
median17.1
Q369
95-th percentile943
Maximum962
Range978
Interquartile range (IQR)68

Descriptive statistics

Standard deviation259.4079798
Coefficient of variation (CV)2.280308754
Kurtosis5.989167861
Mean113.7600246
Median Absolute Deviation (MAD)17.1
Skewness2.762372839
Sum9682798.25
Variance67292.49999
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
01363616.0%
 
126523.1%
 
311611.4%
 
594520.5%
 
674490.5%
 
9424430.5%
 
9484410.5%
 
484410.5%
 
9404320.5%
 
604320.5%
 
Other values (1168)6457775.9%
 
ValueCountFrequency (%) 
-161< 0.1%
 
-15.41< 0.1%
 
-12.61< 0.1%
 
-12.21< 0.1%
 
-11.81< 0.1%
 
ValueCountFrequency (%) 
9626< 0.1%
 
9619< 0.1%
 
96033< 0.1%
 
959510.1%
 
958710.1%
 

H06
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1164
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean113.9954548
Minimum-16.5
Maximum962
Zeros13622
Zeros (%)16.0%
Memory size665.0 KiB

Quantile statistics

Minimum-16.5
5-th percentile0
Q11
median16.7
Q371
95-th percentile943
Maximum962
Range978.5
Interquartile range (IQR)70

Descriptive statistics

Standard deviation259.4049898
Coefficient of variation (CV)2.275573094
Kurtosis5.978166492
Mean113.9954548
Median Absolute Deviation (MAD)16.7
Skewness2.759574225
Sum9702837.13
Variance67290.94872
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
01362216.0%
 
126413.1%
 
312131.4%
 
624690.6%
 
544610.5%
 
594520.5%
 
9404420.5%
 
9424420.5%
 
9484390.5%
 
9464340.5%
 
Other values (1154)6450175.8%
 
ValueCountFrequency (%) 
-16.51< 0.1%
 
-161< 0.1%
 
-13.31< 0.1%
 
-12.81< 0.1%
 
-12.11< 0.1%
 
ValueCountFrequency (%) 
9626< 0.1%
 
9618< 0.1%
 
96030< 0.1%
 
959520.1%
 
958680.1%
 

H07
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1156
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean114.3370246
Minimum-16.8
Maximum966
Zeros12823
Zeros (%)15.1%
Memory size665.0 KiB

Quantile statistics

Minimum-16.8
5-th percentile0
Q11
median16.2
Q372
95-th percentile943
Maximum966
Range982.8
Interquartile range (IQR)71

Descriptive statistics

Standard deviation259.415665
Coefficient of variation (CV)2.268868425
Kurtosis5.965962636
Mean114.3370246
Median Absolute Deviation (MAD)16.2
Skewness2.756368304
Sum9731910.19
Variance67296.48726
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
01282315.1%
 
128023.3%
 
312451.5%
 
24970.6%
 
624730.6%
 
544430.5%
 
654410.5%
 
674380.5%
 
9424370.5%
 
534360.5%
 
Other values (1146)6508176.5%
 
ValueCountFrequency (%) 
-16.81< 0.1%
 
-16.41< 0.1%
 
-141< 0.1%
 
-13.31< 0.1%
 
-12.41< 0.1%
 
ValueCountFrequency (%) 
9661< 0.1%
 
9625< 0.1%
 
96112< 0.1%
 
96030< 0.1%
 
959530.1%
 

H08
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1146
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean115.8759859
Minimum-17
Maximum962
Zeros10868
Zeros (%)12.8%
Memory size665.0 KiB

Quantile statistics

Minimum-17
5-th percentile0
Q11.3
median18.3
Q374
95-th percentile943
Maximum962
Range979
Interquartile range (IQR)72.7

Descriptive statistics

Standard deviation258.9126736
Coefficient of variation (CV)2.234394568
Kurtosis5.977721049
Mean115.8759859
Median Absolute Deviation (MAD)18.3
Skewness2.758382503
Sum9862900.42
Variance67035.77256
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
01086812.8%
 
117742.1%
 
38211.0%
 
595140.6%
 
534890.6%
 
624790.6%
 
674750.6%
 
24730.6%
 
614670.5%
 
684540.5%
 
Other values (1136)6830280.2%
 
ValueCountFrequency (%) 
-171< 0.1%
 
-16.41< 0.1%
 
-14.51< 0.1%
 
-13.51< 0.1%
 
-12.81< 0.1%
 
ValueCountFrequency (%) 
9625< 0.1%
 
96113< 0.1%
 
96037< 0.1%
 
959550.1%
 
958670.1%
 

H09
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1182
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean122.2208835
Minimum-16.8
Maximum963
Zeros9345
Zeros (%)11.0%
Memory size665.0 KiB

Quantile statistics

Minimum-16.8
5-th percentile0
Q13
median23
Q380
95-th percentile944
Maximum963
Range979.8
Interquartile range (IQR)77

Descriptive statistics

Standard deviation258.4882205
Coefficient of variation (CV)2.114926788
Kurtosis5.78148757
Mean122.2208835
Median Absolute Deviation (MAD)23
Skewness2.707384322
Sum10402952.72
Variance66816.16015
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0934511.0%
 
15290.6%
 
675100.6%
 
595010.6%
 
485000.6%
 
624850.6%
 
534830.6%
 
544730.6%
 
704550.5%
 
9414520.5%
 
Other values (1172)7138383.9%
 
ValueCountFrequency (%) 
-16.81< 0.1%
 
-16.61< 0.1%
 
-14.71< 0.1%
 
-13.31< 0.1%
 
-131< 0.1%
 
ValueCountFrequency (%) 
9631< 0.1%
 
9627< 0.1%
 
96120< 0.1%
 
96040< 0.1%
 
959620.1%
 

H10
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1388
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean133.4712653
Minimum-14
Maximum963
Zeros9106
Zeros (%)10.7%
Memory size665.0 KiB

Quantile statistics

Minimum-14
5-th percentile0
Q14.48
median28.7
Q383
95-th percentile944
Maximum963
Range977
Interquartile range (IQR)78.52

Descriptive statistics

Standard deviation262.8700476
Coefficient of variation (CV)1.969487942
Kurtosis4.839097873
Mean133.4712653
Median Absolute Deviation (MAD)28.22
Skewness2.497385927
Sum11360540.22
Variance69100.66194
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0910610.7%
 
535330.6%
 
485290.6%
 
505290.6%
 
445180.6%
 
465140.6%
 
495120.6%
 
595060.6%
 
545030.6%
 
434850.6%
 
Other values (1378)7138183.9%
 
ValueCountFrequency (%) 
-141< 0.1%
 
-13.61< 0.1%
 
-11.52< 0.1%
 
-11.11< 0.1%
 
-10.71< 0.1%
 
ValueCountFrequency (%) 
9634< 0.1%
 
96210< 0.1%
 
96130< 0.1%
 
960460.1%
 
959620.1%
 

H11
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1576
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean146.7147251
Minimum-55
Maximum963
Zeros9067
Zeros (%)10.7%
Memory size665.0 KiB

Quantile statistics

Minimum-55
5-th percentile0
Q16.2
median30
Q384
95-th percentile944
Maximum963
Range1018
Interquartile range (IQR)77.8

Descriptive statistics

Standard deviation274.6193143
Coefficient of variation (CV)1.871791084
Kurtosis3.432677928
Mean146.7147251
Median Absolute Deviation (MAD)29
Skewness2.206320919
Sum12487770.54
Variance75415.76778
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0906710.7%
 
446000.7%
 
455840.7%
 
435750.7%
 
425710.7%
 
475600.7%
 
485550.7%
 
465440.6%
 
495390.6%
 
405210.6%
 
Other values (1566)7100083.4%
 
ValueCountFrequency (%) 
-551< 0.1%
 
-30.21< 0.1%
 
-251< 0.1%
 
-241< 0.1%
 
-8.71< 0.1%
 
ValueCountFrequency (%) 
9636< 0.1%
 
96215< 0.1%
 
96133< 0.1%
 
96040< 0.1%
 
959680.1%
 

H12
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1740
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean158.6176158
Minimum-55
Maximum965
Zeros9056
Zeros (%)10.6%
Memory size665.0 KiB

Quantile statistics

Minimum-55
5-th percentile0
Q17.7
median30.3
Q385
95-th percentile944
Maximum965
Range1020
Interquartile range (IQR)77.3

Descriptive statistics

Standard deviation289.9087739
Coefficient of variation (CV)1.827721167
Kurtosis2.408176622
Mean158.6176158
Median Absolute Deviation (MAD)28.9
Skewness2.000924758
Sum13500896.99
Variance84047.09718
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0905610.6%
 
366060.7%
 
396020.7%
 
385820.7%
 
435790.7%
 
445740.7%
 
475710.7%
 
425600.7%
 
405510.6%
 
375440.6%
 
Other values (1730)7089183.3%
 
ValueCountFrequency (%) 
-552< 0.1%
 
-253< 0.1%
 
-5.41< 0.1%
 
-4.42< 0.1%
 
-4.31< 0.1%
 
ValueCountFrequency (%) 
9651< 0.1%
 
9633< 0.1%
 
96218< 0.1%
 
96132< 0.1%
 
96039< 0.1%
 

H13
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1805
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean166.9692197
Minimum-55
Maximum1040
Zeros9043
Zeros (%)10.6%
Memory size665.0 KiB

Quantile statistics

Minimum-55
5-th percentile0
Q18.8
median30
Q386
95-th percentile944
Maximum1040
Range1095
Interquartile range (IQR)77.2

Descriptive statistics

Standard deviation302.8195051
Coefficient of variation (CV)1.813624725
Kurtosis1.951684057
Mean166.9692197
Median Absolute Deviation (MAD)28.35
Skewness1.907716849
Sum14211752.1
Variance91699.6527
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0904310.6%
 
326910.8%
 
346290.7%
 
356140.7%
 
336130.7%
 
396090.7%
 
316080.7%
 
305950.7%
 
365760.7%
 
415700.7%
 
Other values (1795)7056882.9%
 
ValueCountFrequency (%) 
-551< 0.1%
 
-391< 0.1%
 
-252< 0.1%
 
-23.41< 0.1%
 
-101< 0.1%
 
ValueCountFrequency (%) 
10401< 0.1%
 
10391< 0.1%
 
10131< 0.1%
 
10111< 0.1%
 
10092< 0.1%
 

H14
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1905
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean171.2312925
Minimum-55
Maximum1062
Zeros9036
Zeros (%)10.6%
Memory size665.0 KiB

Quantile statistics

Minimum-55
5-th percentile0
Q19.6
median29
Q390
95-th percentile946
Maximum1062
Range1117
Interquartile range (IQR)80.4

Descriptive statistics

Standard deviation309.6533738
Coefficient of variation (CV)1.808392434
Kurtosis1.821844382
Mean171.2312925
Median Absolute Deviation (MAD)27.15
Skewness1.878045987
Sum14574522.69
Variance95885.21189
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0903610.6%
 
307150.8%
 
327100.8%
 
287050.8%
 
316830.8%
 
296790.8%
 
336290.7%
 
266280.7%
 
276050.7%
 
356020.7%
 
Other values (1895)7012482.4%
 
ValueCountFrequency (%) 
-551< 0.1%
 
-44.81< 0.1%
 
-251< 0.1%
 
-161< 0.1%
 
-3.81< 0.1%
 
ValueCountFrequency (%) 
10621< 0.1%
 
10611< 0.1%
 
10581< 0.1%
 
10551< 0.1%
 
10541< 0.1%
 

H15
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1920
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean170.7342211
Minimum-55
Maximum1126
Zeros9019
Zeros (%)10.6%
Memory size665.0 KiB

Quantile statistics

Minimum-55
5-th percentile0
Q110
median28.3
Q396
95-th percentile946
Maximum1126
Range1181
Interquartile range (IQR)86

Descriptive statistics

Standard deviation308.3709509
Coefficient of variation (CV)1.80614612
Kurtosis1.893747581
Mean170.7342211
Median Absolute Deviation (MAD)26.32
Skewness1.890757156
Sum14532213.96
Variance95092.64337
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0901910.6%
 
287640.9%
 
297570.9%
 
277500.9%
 
267030.8%
 
246970.8%
 
256970.8%
 
316300.7%
 
306210.7%
 
226040.7%
 
Other values (1910)6987482.1%
 
ValueCountFrequency (%) 
-552< 0.1%
 
-252< 0.1%
 
-24.81< 0.1%
 
-3.51< 0.1%
 
-31< 0.1%
 
ValueCountFrequency (%) 
11261< 0.1%
 
11131< 0.1%
 
11001< 0.1%
 
10971< 0.1%
 
10731< 0.1%
 

H16
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1894
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean164.9913335
Minimum-55
Maximum1074
Zeros8958
Zeros (%)10.5%
Memory size665.0 KiB

Quantile statistics

Minimum-55
5-th percentile0
Q110.1
median28
Q399
95-th percentile944
Maximum1074
Range1129
Interquartile range (IQR)88.9

Descriptive statistics

Standard deviation299.6633098
Coefficient of variation (CV)1.816236668
Kurtosis2.156257223
Mean164.9913335
Median Absolute Deviation (MAD)25.97
Skewness1.948001125
Sum14043402.34
Variance89798.09923
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0895810.5%
 
237820.9%
 
277170.8%
 
257130.8%
 
227070.8%
 
267030.8%
 
247000.8%
 
286940.8%
 
216800.8%
 
306470.8%
 
Other values (1884)6981582.0%
 
ValueCountFrequency (%) 
-553< 0.1%
 
-253< 0.1%
 
-3.21< 0.1%
 
-2.81< 0.1%
 
-2.71< 0.1%
 
ValueCountFrequency (%) 
10741< 0.1%
 
10681< 0.1%
 
10321< 0.1%
 
10231< 0.1%
 
10221< 0.1%
 

H17
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1864
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean155.9684796
Minimum-55
Maximum1018
Zeros8944
Zeros (%)10.5%
Memory size665.0 KiB

Quantile statistics

Minimum-55
5-th percentile0
Q19.9
median27.6
Q394
95-th percentile942
Maximum1018
Range1073
Interquartile range (IQR)84.1

Descriptive statistics

Standard deviation287.1686095
Coefficient of variation (CV)1.841196441
Kurtosis2.650596941
Mean155.9684796
Median Absolute Deviation (MAD)25.52
Skewness2.051588951
Sum13275413.11
Variance82465.81028
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0894410.5%
 
218171.0%
 
227560.9%
 
237280.9%
 
257080.8%
 
206990.8%
 
286900.8%
 
276620.8%
 
246570.8%
 
296510.8%
 
Other values (1854)6980482.0%
 
ValueCountFrequency (%) 
-551< 0.1%
 
-41.81< 0.1%
 
-27.21< 0.1%
 
-251< 0.1%
 
-151< 0.1%
 
ValueCountFrequency (%) 
10181< 0.1%
 
9621< 0.1%
 
9612< 0.1%
 
96011< 0.1%
 
95930< 0.1%
 

H18
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1738
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean144.5657306
Minimum-3.5
Maximum962
Zeros8971
Zeros (%)10.5%
Memory size665.0 KiB

Quantile statistics

Minimum-3.5
5-th percentile0
Q18.8
median27
Q384
95-th percentile942
Maximum962
Range965.5
Interquartile range (IQR)75.2

Descriptive statistics

Standard deviation273.9796637
Coefficient of variation (CV)1.895190945
Kurtosis3.533076322
Mean144.5657306
Median Absolute Deviation (MAD)24.96
Skewness2.229019012
Sum12304856.73
Variance75064.85614
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0897110.5%
 
237460.9%
 
247410.9%
 
227150.8%
 
197120.8%
 
216930.8%
 
176840.8%
 
256780.8%
 
206770.8%
 
186720.8%
 
Other values (1728)6982782.0%
 
ValueCountFrequency (%) 
-3.51< 0.1%
 
-31< 0.1%
 
-2.91< 0.1%
 
-2.81< 0.1%
 
-1.61< 0.1%
 
ValueCountFrequency (%) 
9621< 0.1%
 
9612< 0.1%
 
96012< 0.1%
 
95930< 0.1%
 
958520.1%
 

H19
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1567
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean133.6705625
Minimum-4.2
Maximum963
Zeros9638
Zeros (%)11.3%
Memory size665.0 KiB

Quantile statistics

Minimum-4.2
5-th percentile0
Q15
median26
Q378
95-th percentile942
Maximum963
Range967.2
Interquartile range (IQR)73

Descriptive statistics

Standard deviation264.4898623
Coefficient of variation (CV)1.978669479
Kurtosis4.597175484
Mean133.6705625
Median Absolute Deviation (MAD)24.38
Skewness2.443141143
Sum11377503.6
Variance69954.88724
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0963811.3%
 
18871.0%
 
217180.8%
 
246950.8%
 
226900.8%
 
236780.8%
 
186600.8%
 
196440.8%
 
286420.8%
 
256380.7%
 
Other values (1557)6922681.3%
 
ValueCountFrequency (%) 
-4.21< 0.1%
 
-3.91< 0.1%
 
-3.71< 0.1%
 
-3.41< 0.1%
 
-31< 0.1%
 
ValueCountFrequency (%) 
9631< 0.1%
 
9615< 0.1%
 
96015< 0.1%
 
95936< 0.1%
 
958530.1%
 

H20
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1355
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean124.7169745
Minimum-6.5
Maximum963
Zeros10515
Zeros (%)12.4%
Memory size665.0 KiB

Quantile statistics

Minimum-6.5
5-th percentile0
Q13
median25
Q372
95-th percentile942
Maximum963
Range969.5
Interquartile range (IQR)69

Descriptive statistics

Standard deviation259.9601756
Coefficient of variation (CV)2.084400914
Kurtosis5.426211471
Mean124.7169745
Median Absolute Deviation (MAD)23.85
Skewness2.622394332
Sum10615410
Variance67579.29288
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
01051512.4%
 
112721.5%
 
216270.7%
 
196110.7%
 
256100.7%
 
236070.7%
 
206030.7%
 
225780.7%
 
275760.7%
 
245760.7%
 
Other values (1345)6854180.5%
 
ValueCountFrequency (%) 
-6.51< 0.1%
 
-5.51< 0.1%
 
-5.31< 0.1%
 
-4.61< 0.1%
 
-4.41< 0.1%
 
ValueCountFrequency (%) 
9631< 0.1%
 
9621< 0.1%
 
9618< 0.1%
 
96019< 0.1%
 
95940< 0.1%
 

H21
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1274
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean118.5121847
Minimum-7.8
Maximum963
Zeros11299
Zeros (%)13.3%
Memory size665.0 KiB

Quantile statistics

Minimum-7.8
5-th percentile0
Q12.22
median23.3
Q364
95-th percentile942
Maximum963
Range970.8
Interquartile range (IQR)61.78

Descriptive statistics

Standard deviation259.4985687
Coefficient of variation (CV)2.189636192
Kurtosis5.748996795
Mean118.5121847
Median Absolute Deviation (MAD)22.3
Skewness2.703393711
Sum10087283.11
Variance67339.50715
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
01129913.3%
 
116692.0%
 
36260.7%
 
225750.7%
 
235730.7%
 
215720.7%
 
265660.7%
 
255610.7%
 
205470.6%
 
285460.6%
 
Other values (1264)6758279.4%
 
ValueCountFrequency (%) 
-7.81< 0.1%
 
-6.91< 0.1%
 
-6.41< 0.1%
 
-5.81< 0.1%
 
-5.31< 0.1%
 
ValueCountFrequency (%) 
9631< 0.1%
 
9624< 0.1%
 
9617< 0.1%
 
96024< 0.1%
 
959500.1%
 

H22
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1223
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean115.9862753
Minimum-8.9
Maximum963
Zeros12549
Zeros (%)14.7%
Memory size665.0 KiB

Quantile statistics

Minimum-8.9
5-th percentile0
Q11.33
median21
Q360
95-th percentile942
Maximum963
Range971.9
Interquartile range (IQR)58.67

Descriptive statistics

Standard deviation260.2016279
Coefficient of variation (CV)2.243382911
Kurtosis5.774071724
Mean115.9862753
Median Absolute Deviation (MAD)20.35
Skewness2.711662077
Sum9872287.81
Variance67704.88719
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
01254914.7%
 
123392.7%
 
39881.2%
 
225620.7%
 
285460.6%
 
295250.6%
 
264980.6%
 
234980.6%
 
204950.6%
 
314950.6%
 
Other values (1213)6562177.1%
 
ValueCountFrequency (%) 
-8.91< 0.1%
 
-8.41< 0.1%
 
-7.91< 0.1%
 
-6.81< 0.1%
 
-6.22< 0.1%
 
ValueCountFrequency (%) 
9633< 0.1%
 
9625< 0.1%
 
96110< 0.1%
 
96032< 0.1%
 
959520.1%
 

H23
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1211
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean115.4614524
Minimum-9.8
Maximum964
Zeros13518
Zeros (%)15.9%
Memory size665.0 KiB

Quantile statistics

Minimum-9.8
5-th percentile0
Q11
median20.8
Q362
95-th percentile943
Maximum964
Range973.8
Interquartile range (IQR)61

Descriptive statistics

Standard deviation260.287468
Coefficient of variation (CV)2.254323522
Kurtosis5.79989435
Mean115.4614524
Median Absolute Deviation (MAD)20.5
Skewness2.718353217
Sum9827616.98
Variance67749.566
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
01351815.9%
 
126093.1%
 
311541.4%
 
314840.6%
 
324830.6%
 
294720.6%
 
284700.6%
 
254640.5%
 
224620.5%
 
234610.5%
 
Other values (1201)6453975.8%
 
ValueCountFrequency (%) 
-9.81< 0.1%
 
-9.61< 0.1%
 
-8.71< 0.1%
 
-7.61< 0.1%
 
-7.41< 0.1%
 
ValueCountFrequency (%) 
9641< 0.1%
 
9633< 0.1%
 
9626< 0.1%
 
96111< 0.1%
 
96038< 0.1%
 

H24
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct1219
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean114.6194547
Minimum-11
Maximum964
Zeros13509
Zeros (%)15.9%
Memory size665.0 KiB

Quantile statistics

Minimum-11
5-th percentile0
Q11
median20.2
Q363
95-th percentile943
Maximum964
Range975
Interquartile range (IQR)62

Descriptive statistics

Standard deviation260.0589335
Coefficient of variation (CV)2.26888999
Kurtosis5.873753634
Mean114.6194547
Median Absolute Deviation (MAD)20.15
Skewness2.735973359
Sum9755949.51
Variance67630.64891
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
01350915.9%
 
125763.0%
 
311581.4%
 
284840.6%
 
334570.5%
 
324540.5%
 
9404470.5%
 
314470.5%
 
9414430.5%
 
9474400.5%
 
Other values (1209)6470176.0%
 
ValueCountFrequency (%) 
-112< 0.1%
 
-9.21< 0.1%
 
-8.61< 0.1%
 
-8.42< 0.1%
 
-8.31< 0.1%
 
ValueCountFrequency (%) 
9643< 0.1%
 
9631< 0.1%
 
9627< 0.1%
 
96111< 0.1%
 
960440.1%
 

FECHA
Date

Distinct941
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size665.0 KiB
Minimum2019-01-01 00:00:00
Maximum2021-09-30 00:00:00
Histogram with fixed size bins (bins=50)

CALLE
Categorical

HIGH CORRELATION

Distinct26
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size665.0 KiB
JMD Moratalaz
6966 
Parque Juan Carlos I
6854 
JMD Villaverde
6794 
Centro Municipal de Acústica
6491 
Casa de Campo
6481 
Other values (21)
51530 
ValueCountFrequency (%) 
JMD Moratalaz69668.2%
 
Parque Juan Carlos I68548.1%
 
JMD Villaverde67948.0%
 
Centro Municipal de Acústica64917.6%
 
Casa de Campo64817.6%
 
JMD Hortaleza61167.2%
 
Ensanche de Vallecas60987.2%
 
Peñagrande53736.3%
 
Plaza Elíptica53116.2%
 
EDAR La China23432.8%
 
Other values (16)2628930.9%
 
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%
Histogram of lengths of the category

Length

Max length28
Median length14
Mean length15.02108887
Min length8

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Missing values

Sample

First rows

ESTACIONMAGNITUDPUNTO_MUESTREOANOMESDIAH01H02H03H04H05H06H07H08H09H10H11H12H13H14H15H16H17H18H19H20H21H22H23H24FECHACALLE
0102Wind Velocity(m/s)28079102_81_982019110.650.950.870.730.570.570.800.850.900.730.851.020.620.450.770.350.980.470.370.430.580.380.670.182019-01-01JMD Moratalaz
1106Barometric Pressure(mb)28079106_87_98201911960.00960.00960.00960.00960.00959.00959.00960.00959.00960.00960.00960.00960.00959.00959.00959.00959.00959.00959.00959.00960.00959.00959.00960.002019-01-01Centro Municipal de Acústica
2106Solar Radiation(W/m^2)28079106_88_982019110.000.000.000.000.000.000.000.006.00122.00275.00349.00417.00429.00379.00282.00149.0023.000.000.000.000.000.000.002019-01-01Centro Municipal de Acústica
3106Precipitation(l/m^2)28079106_89_982019110.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.002019-01-01Centro Municipal de Acústica
4107Wind Velocity(m/s)28079107_81_982019110.450.350.280.400.300.370.520.330.350.570.580.420.520.280.350.380.380.270.000.000.000.300.400.022019-01-01JMD Hortaleza
559Wind Direction28079059_82_982019115.003.00354.00357.00343.0027.0027.00279.0020.0024.0032.0015.0043.0095.0091.00119.0061.00227.00239.00275.00340.00312.00339.00344.002019-01-01Parque Juan Carlos I
6107Wind Direction28079107_82_9820191141.0014.0031.0039.0015.0036.0021.0025.0022.0032.0028.0059.0013.0036.004.0062.00146.00206.0031.0014.0053.0033.0023.0015.002019-01-01JMD Hortaleza
7107Temperature(ºC)28079107_83_982019114.003.202.902.401.201.200.800.700.902.504.807.909.8012.3013.6014.2014.4010.807.806.706.405.604.203.302019-01-01JMD Hortaleza
8107Relative Humidity(%)28079107_86_9820191152.0054.0054.0054.0057.0055.0057.0058.0057.0051.0044.0037.0032.0030.0028.0025.0027.0037.0048.0051.0054.0055.0058.0061.002019-01-01JMD Hortaleza
9107Barometric Pressure(mb)28079107_87_98201911949.00949.00948.00949.00948.00948.00948.00948.00949.00949.00949.00949.00949.00949.00948.00948.00948.00948.00948.00948.00949.00949.00948.00948.002019-01-01JMD Hortaleza

Last rows

ESTACIONMAGNITUDPUNTO_MUESTREOANOMESDIAH01H02H03H04H05H06H07H08H09H10H11H12H13H14H15H16H17H18H19H20H21H22H23H24FECHACALLE
85106107Precipitation(l/m^2)28079107_89_9820219300.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.002021-09-30JMD Hortaleza
85107103Precipitation(l/m^2)28079103_89_9820219300.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.002021-09-30JMD Villaverde
8510858Temperature(ºC)28079058_83_98202193014.0016.0015.1014.2013.0012.4013.9013.7013.2014.0017.6019.8023.3024.5025.0023.8024.9026.2024.7023.5020.3017.7016.1014.902021-09-30El Pardo
85109104Wind Velocity(m/s)28079104_81_9820219300.650.430.650.770.770.570.630.350.330.380.520.530.650.930.700.780.650.600.300.030.000.000.030.022021-09-30EDAR La China
8511054Wind Velocity(m/s)28079054_81_9820219301.271.221.351.111.031.120.981.051.061.151.070.860.880.960.931.151.171.110.830.590.600.500.460.562021-09-30Ensanche de Vallecas
85111107Solar Radiation(W/m^2)28079107_88_9820219300.000.000.000.000.000.000.000.0015.0090.00253.00373.00685.00736.00753.00633.00426.00341.00212.0035.000.000.000.000.002021-09-30JMD Hortaleza
85112104Wind Direction28079104_82_9820219306.00356.00351.0010.0026.006.009.0021.008.0048.005.0031.00176.00180.00183.008.000.0024.0027.0047.0039.009.0034.0044.002021-09-30EDAR La China
8511335Relative Humidity(%)28079035_86_98202193046.0053.0057.0059.0060.0060.0060.0060.0060.0058.0057.0056.0056.0052.0046.0038.0038.0037.0039.0040.0040.0044.0048.0053.002021-09-30Plaza del Carmen
85114108Wind Velocity(m/s)28079108_81_9820219301.771.481.151.001.031.271.221.031.171.121.051.100.920.970.851.050.850.730.680.380.380.420.530.302021-09-30Peñagrande
8511524Wind Direction28079024_82_982021930324.00346.00329.000.000.001.0020.0020.00233.00314.002.0056.0075.0075.0036.0033.0047.0092.00196.0091.00180.00232.004.0037.002021-09-30Casa de Campo

Duplicate rows

Most frequent

ESTACIONMAGNITUDPUNTO_MUESTREOANOMESDIAH01H02H03H04H05H06H07H08H09H10H11H12H13H14H15H16H17H18H19H20H21H22H23H24FECHACALLEcount
04Temperature(ºC)28079004_83_9820199123.322.321.420.620.620.218.518.219.020.324.327.029.231.031.832.831.730.029.929.629.228.226.925.12019-09-01Plaza de España2
14Temperature(ºC)28079004_83_9820199222.821.620.920.119.619.318.918.518.619.020.623.225.627.429.130.531.532.431.730.629.228.627.826.52019-09-02Plaza de España2
24Temperature(ºC)28079004_83_9820199324.623.422.521.721.020.520.219.920.421.323.725.827.228.730.732.232.933.933.732.330.529.428.527.32019-09-03Plaza de España2
34Temperature(ºC)28079004_83_9820199426.626.424.021.119.818.718.618.318.820.124.026.428.530.531.933.133.634.534.031.931.330.228.625.62019-09-04Plaza de España2
44Temperature(ºC)28079004_83_9820199523.722.521.520.419.519.018.217.717.417.819.120.822.624.225.926.426.827.526.925.524.622.821.018.82019-09-05Plaza de España2
54Temperature(ºC)28079004_83_9820199617.716.616.015.314.513.913.012.912.813.515.117.319.421.523.625.126.026.826.325.525.224.122.520.82019-09-06Plaza de España2
64Temperature(ºC)28079004_83_9820199719.318.117.015.915.615.315.115.115.215.716.919.321.824.225.826.828.829.428.827.326.726.224.222.42019-09-07Plaza de España2
74Temperature(ºC)28079004_83_9820199821.320.219.218.418.118.318.217.817.818.520.122.224.025.927.328.729.929.929.428.227.426.625.123.52019-09-08Plaza de España2
84Temperature(ºC)28079004_83_9820199921.820.519.718.517.416.415.415.215.016.220.323.225.728.129.229.729.829.928.427.426.425.223.722.92019-09-09Plaza de España2
94Temperature(ºC)28079004_83_98201991022.621.520.018.717.917.016.216.116.015.315.916.719.320.921.620.819.519.117.116.416.316.415.915.62019-09-10Plaza de España2